package com.recycler.coverflow.wcdb;

public interface DB1 {
    String tbl_name = "keige_tbl_song_lrc";
    String tbl_name_index = "keige_tbl_song_lrc";
    String column_name = "conten";


    String searchLikePro = " select "+column_name
            +" from "+tbl_name
            +" where "+column_name+" like "
            ;

    String limited30 = " limit "+30;

    String createFt3 = "CREATE VIRTUAL TABLE " +tbl_name+
            " USING fts3(" +column_name+
            ");";

    String searchMathPro = "SELECT * FROM " +tbl_name_index+
            " WHERE " +column_name+
            " MATCH ";

    String COUNT_TBL = "SELECT COUNT(*) FROM "+tbl_name;
}
